# coding=utf-8
import os

import xlrd
import xlwt
import xlutils

data_path = os.path.join('F:\pythonProjrect\itf_simple', 'data')  # os.path.join()函数：连接两个或更多的路径名
print(data_path)

#打开文件
# file = open(filename,'rb')


def getPTable():
    #打开excel文件
    chengguoxls =xlrd.open_workbook("HS-汕尾项目总库成果表 - v1.xlsx")
    # chengguoxls = chengguoxls.decode('utf-8')
    chengguosheet = chengguoxls.sheet_by_name("Sheet1")
    row =chengguosheet.nrows #总行数
    for i in range(row):
        rowdata =chengguosheet.row_values(i)#i行的list
        print(rowdata)
        for index,indexValue in enumerate(rowdata):
            print(i,index,indexValue)#第i行，a列，数据b


if __name__ == '__main__':
    getPTable()